Tabela VaccineScheduleVersion

Definicja tabeli VaccineScheduleVersion

Name

VaccineScheduleVersion

Code

VaccineScheduleVersion

Comment

Wersja kalendarza szczepien


Lista kolumn tabeli VaccineScheduleVersion

Name

Code

VaccineScheduleVersionID

VaccineScheduleVersionID

Active

Active

StartDT

StartDT

StopDT

StopDT

ShortName

ShortName

FullName

FullName


Kolumna VaccineScheduleVersionID tabeli VaccineScheduleVersion

Definicja kolumny VaccineScheduleVersionID tabeli VaccineScheduleVersion

Name

VaccineScheduleVersionID

Code

VaccineScheduleVersionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli VaccineScheduleVersion

Definicja kolumny Active tabeli VaccineScheduleVersion

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli VaccineScheduleVersion

Definicja kolumny StartDT tabeli VaccineScheduleVersion

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

okres obowiazywania od


Kolumna StopDT tabeli VaccineScheduleVersion

Definicja kolumny StopDT tabeli VaccineScheduleVersion

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

okres obowiazywania do


Kolumna ShortName tabeli VaccineScheduleVersion

Definicja kolumny ShortName tabeli VaccineScheduleVersion

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

nazwa kalendarza


Kolumna FullName tabeli VaccineScheduleVersion

Definicja kolumny FullName tabeli VaccineScheduleVersion

Name

FullName

Code

FullName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

nazwa kalendarza


Lista kluczy tabeli VaccineScheduleVersion

Name

Code

Primary

PK_VaccineScheduleVersion

PK_VaccineScheduleVersion

X


Klucz PK_VaccineScheduleVersion tabeli VaccineScheduleVersion

Definicja klucza PK_VaccineScheduleVersion tabeli VaccineScheduleVersion

Name

PK_VaccineScheduleVersion

Code

PK_VaccineScheduleVersion

Primary

Yes

Comment